SELECT Id FROM new_searchtable
where (water_body like 'Sunapee%') and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lake Sunapee NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Enjoy a brand new 2026 built energy efficient home in this spectacular Lake Sunapee setting offering 131' prime shoreline, a lush lawn at the waterfront & a 2016 built 2 bay boathouse with over-water recreation space. The 5 bedroom design features open concept living/kitchen/dining with a first floor bedroom, 4 large bedrooms up and options to finish areas over the garage and in the walk-out lowest level. Currently an existing seasonal structure can be used and enjoyed while you finalize all building plans with Snow Construction (or other builder of your choice). Options available to purchase the current seasonal cottage only if you are seeking a seasonal option - or wish to build new at a later date. This Lake Sunapee home is located near the base of Mt. Sunapee Ski Resort. Enjoy hiking trails through a 100 acre adjacent preserve right across the street. Ride your bike to the sandy State Beach for a picnic. Mt. Sunapee offers an adventure park , zip lines & many cultural events in summer & 344 acres of ski trails to explore in winter.
Description:Discover lakeside luxury with this exquisite 6-bedroom contemporary home, set on 236 feet of prime Lake Sunapee shoreline. Enjoy broad water and Herrick Lighthouse views from every room, along with the rare amenity of a two-bay boathouse featuring a recreation space above. Private, end-of-road location and bordered by 17 acres of forever-conserved land with 3/10 mile of protected shoreline, this property ensures unmatched privacy. Open-concept living spaces boast floor-to-ceiling windows framing sparkling lake views and distant mountain panoramas. The main level includes a gourmet kitchen, a cozy lakefront living room with fireplace, a private media room, and access to open decks and a serene screened porch overlooking the water. The primary lakefront bedroom suite offers its own private deck, fireplace, spa bathroom with double headed shower and a soaking tub overlooking a striking granite wall formation surrounded by lush gardens. A private adjacent den serves as an ideal retreat. Upstairs, three generously sized bedrooms each feature en-suite luxurious baths. All baths throughout have double sinks. The lower level provides additional space for relaxation and entertainment, including a media/recreation room and two more bedrooms with en-suite baths (including a steam bath), all with access to lakefront decks. Enjoy a wide variety of waterfront activities with docking space for 5 to 6 boats including the deep water boathouse. Convenient location for commuting.